-
Re: Reporting Tasks Late or On Time - issue with Date Completed is blank incorrect response
To address the issue you're experiencing with your Smartsheet formula, especially with handling tasks where "Date Completed" is blank and ensuring they are reported as "Late" if t…1 · -
Re: Multiplication and addition in one calculation error
Hi @Sarah Hole, The issue you're encountering stems from the syntax and structure of the formulas you're trying to create in Smartsheet. When you want to add a percentage to one cost and then add add…1 · -
Re: Hotel day to day management
Hi @Neal_Avalon Staff, It sounds like you're looking to leverage Smartsheet to its full potential for managing and reporting on your motel's operations. Based on the requirements you've outlined—capt…1 · -
Re: Community Category: Best Practice
@Genevieve P I think it's better to add an option in the comments to select the post as a "Best Practice" like what we do for VOTE & INSIGHTFULL, it's easier to rember than all that ste…2 · -
Re: How to automate the RYG status balls
Hi @Janice Phua Hope you are fine,please use the following formula: =IF([% Complete]@row = 1, "Green", IF(AND([% Complete]@row >= 0.7, [% Complete]@row < 1), "Yellow", "…3 ·